Tabela CO_RECIPE

Definicja tabeli CO_RECIPE

Name

CO_RECIPE

Code

CO_RECIPE

Comment

 


Lista kolumn tabeli CO_RECIPE

Name

Code

CO_RECIPEID

CO_RECIPEID

CHEFNAME

CHEFNAME

COOKNAME

COOKNAME

CREATED

CREATED

DISPOSALDESCRIPTION

DISPOSALDESCRIPTION

NAME

NAME

PREPARATIONDESCRIPTION

PREPARATIONDESCRIPTION

PREPARATIONTIME

PREPARATIONTIME

MEALQUANTITY

MEALQUANTITY

ALLERGENS

ALLERGENS

RECIPENUMBER

RECIPENUMBER

PRICENETTO

PRICENETTO

VATRATE

VATRATE

ACTIVE

ACTIVE

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

CO_DISHID

CO_DISHID

PortionQuantity

PortionQuantity

PortionUnitID

PortionUnitID


Kolumna CO_RECIPEID tabeli CO_RECIPE

Definicja kolumny CO_RECIPEID tabeli CO_RECIPE

Name

CO_RECIPEID

Code

CO_RECIPEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CHEFNAME tabeli CO_RECIPE

Definicja kolumny CHEFNAME tabeli CO_RECIPE

Name

CHEFNAME

Code

CHEFNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna COOKNAME tabeli CO_RECIPE

Definicja kolumny COOKNAME tabeli CO_RECIPE

Name

COOKNAME

Code

COOKNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CREATED tabeli CO_RECIPE

Definicja kolumny CREATED tabeli CO_RECIPE

Name

CREATED

Code

CREATED

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna DISPOSALDESCRIPTION tabeli CO_RECIPE

Definicja kolumny DISPOSALDESCRIPTION tabeli CO_RECIPE

Name

DISPOSALDESCRIPTION

Code

DISPOSALDESCRIPTION

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna NAME tabeli CO_RECIPE

Definicja kolumny NAME tabeli CO_RECIPE

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna PREPARATIONDESCRIPTION tabeli CO_RECIPE

Definicja kolumny PREPARATIONDESCRIPTION tabeli CO_RECIPE

Name

PREPARATIONDESCRIPTION

Code

PREPARATIONDESCRIPTION

Data Type

CLOB

Mandatory

Yes

Comment

 


Kolumna PREPARATIONTIME tabeli CO_RECIPE

Definicja kolumny PREPARATIONTIME tabeli CO_RECIPE

Name

PREPARATIONTIME

Code

PREPARATIONTIME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna MEALQUANTITY tabeli CO_RECIPE

Definicja kolumny MEALQUANTITY tabeli CO_RECIPE

Name

MEALQUANTITY

Code

MEALQUANTITY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ALLERGENS tabeli CO_RECIPE

Definicja kolumny ALLERGENS tabeli CO_RECIPE

Name

ALLERGENS

Code

ALLERGENS

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna RECIPENUMBER tabeli CO_RECIPE

Definicja kolumny RECIPENUMBER tabeli CO_RECIPE

Name

RECIPENUMBER

Code

RECIPENUMBER

Data Type

NUMBER(38)

Mandatory

Yes

Comment

 


Kolumna PRICENETTO tabeli CO_RECIPE

Definicja kolumny PRICENETTO tabeli CO_RECIPE

Name

PRICENETTO

Code

PRICENETTO

Data Type

NUMBER(38,2)

Mandatory

No

Comment

 


Kolumna VATRATE tabeli CO_RECIPE

Definicja kolumny VATRATE tabeli CO_RECIPE

Name

VATRATE

Code

VATRATE

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ACTIVE tabeli CO_RECIPE

Definicja kolumny ACTIVE tabeli CO_RECIPE

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_RECIPE

Definicja kolumny INSERTDATE tabeli CO_RECIPE

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_RECIPE

Definicja kolumny INSERTINGPERSON tabeli CO_RECIPE

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_RECIPE

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_RECIPE

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_RECIPE

Definicja kolumny LASTMODIFIEDDT tabeli CO_RECIPE

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CO_DISHID tabeli CO_RECIPE

Definicja kolumny CO_DISHID tabeli CO_RECIPE

Name

CO_DISHID

Code

CO_DISHID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PortionQuantity tabeli CO_RECIPE

Definicja kolumny PortionQuantity tabeli CO_RECIPE

Name

PortionQuantity

Code

PortionQuantity

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

Wielkosc porcji


Kolumna PortionUnitID tabeli CO_RECIPE

Definicja kolumny PortionUnitID tabeli CO_RECIPE

Name

PortionUnitID

Code

PortionUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Jednostka miary


Lista kluczy tabeli CO_RECIPE

Name

Code

Primary

PK_CO_RECIPE

PK_CO_RECIPE

X


Klucz PK_CO_RECIPE tabeli CO_RECIPE

Definicja klucza PK_CO_RECIPE tabeli CO_RECIPE

Name

PK_CO_RECIPE

Code

PK_CO_RECIPE

Primary

Yes

Comment